package com.example.chao.myphotosearch.config;

/**
 * Created by chao on 2016/4/29.
 */
public class MySql  {
    public static final String DB_NAME ="my_search.db";
    public static final String DOWN_LOAD_TABLE = "download";
    public static final String COLLECT_TABLE = "collect";
    public static final int DB_VERSION = 1;

    public static final String createDownLoadTable = "create table if not exists " +DOWN_LOAD_TABLE+
            " (id integer primary key autoincrement,"+
            "fileName varchar,"+
            "largeImgUrl varchar,"+
            "height integer," +
            "width integer)";

    public static final String createCollectTable = "create table if not exists " +COLLECT_TABLE+
            " (id integer primary key autoincrement,"+
            "smallImgUrl varchar," +
            "largeImgUrl varchar," +
            "height integer," +
            "width integer)";
}
